import link1

s = []
for i in range(10):
    st1 = input("请输入你要插入的数据")
    st2 = st1.split(",")
    s.append(st2)
print(s)

try:
    sql1 = f"insert into person values(%s,%s,%s,%s)"
    link1.insert(sql1, s)
except Exception as e:
    print("数据插入失败", e)
# sql1=f"delete from person where username='张三'"
# link1.person.delete(sql1)

sql2 = f"select * from person"
datas = link1.select(sql2)
for i in datas:
    print(i)
